Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_DEF_AUDIT_OPTS

`ALL_DEF_AUDIT_OPTS` contains default object-auditing options that will be applied when objects are created. The output for each column takes one of the following forms:

- `-/-`: no default auditing

- `S/-`: auditing whenever successful

- `-/S`: auditing whenever not successful

Column | Datatype | NULL | Description
--- | --- | --- | ---
`ALT` | `VARCHAR2(3)` |  | Auditing `ALTER WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`AUD` | `VARCHAR2(3)` |  | Auditing `AUDIT WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`COM` | `VARCHAR2(3)` |  | Auditing `COMMENT WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`DEL` | `VARCHAR2(3)` |  | Auditing `DELETE WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`GRA` | `VARCHAR2(3)` |  | Auditing `GRANT WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`IND` | `VARCHAR2(3)` |  | Auditing `INDEX WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`INS` | `VARCHAR2(3)` |  | Auditing `INSERT WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`LOC` | `VARCHAR2(3)` |  | Auditing `LOCK WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`REN` | `VARCHAR2(3)` |  | Auditing `RENAME WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`SEL` | `VARCHAR2(3)` |  | Auditing `SELECT WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`UPD` | `VARCHAR2(3)` |  | Auditing `UPDATE WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`REF` | `CHAR(3)` |  | Auditing `REFERENCES WHENEVER SUCCESSFUL` / `UNSUCCESSFUL` (not used)
`EXE` | `VARCHAR2(3)` |  | Auditing `EXECUTE WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`FBK` | `VARCHAR2(3)` |  | Auditing `FLASHBACK WHENEVER SUCCESSFUL` / `UNSUCCESSFUL`
`REA` | `VARCHAR2(3)` |  | Auditing `READ WHENEVER SUCCESSFUL / UNSUCCESSFUL`